﻿using System;
using Microsoft.EntityFrameworkCore.Migrations;

namespace MyabpDDD.Demo.EntityFrameworkCore.Migrations
{
    public partial class yuhg : Migration
    {
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.CreateTable(
                name: "AccidentrecordsTables",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    ShiGu = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    ChePaiHao = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    MiaoShu = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    ShunShi = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    PeiChang = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    JinShunShi = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Ren = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    ShiGuDate = table.Column<DateTime>(type: "datetime2", nullable: true),
                    BeiZhu = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    CreateDate = table.Column<DateTime>(type: "datetime2", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_AccidentrecordsTables", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "Agenttables",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    AgenttaName = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Agenttables", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "BaoYangTables",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Maintenance = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Licenseplatenumber = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Amount = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Head = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    XiangMu = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    BaoYangDate = table.Column<DateTime>(type: "datetime2", nullable: true),
                    BeiZhu = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    CrrateDate = table.Column<DateTime>(type: "datetime2", nullable: true),
                    DangQian = table.Column<decimal>(type: "decimal(18,2)", nullable: true),
                    ShangDate = table.Column<DateTime>(type: "datetime2", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_BaoYangTables", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "BuMenTables",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    BuMenName = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_BuMenTables", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "Cargoownermanagements",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Creationtime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Cargoownersname = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Phone = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    DanweiName = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Contactaddress = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Driverslicenseexpirationdate = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Driverslicensephoto = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Notes = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Cargoownermanagements", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "CarriagecontractTables",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Contract = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Contracttitle = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Outsourcing = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Cooperation = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Freight = table.Column<int>(type: "int", nullable: true),
                    Condition = table.Column<int>(type: "int", nullable: true),
                    Chartervalue = table.Column<int>(type: "int", nullable: true),
                    Signingdate = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Agent = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Creationtime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    State = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Approver = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_CarriagecontractTables", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "CarrierTables",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    NumBer = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    BiaoTi = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    WaiXieDanWei = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Ren = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    XianLu = table.Column<int>(type: "int", nullable: true),
                    YunJia = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    DunWei = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    JinE = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    QianDinDate = table.Column<DateTime>(type: "datetime2", nullable: true),
                    JinBanRen = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    CreateDate = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Sistrte = table.Column<int>(type: "int", nullable: true),
                    ShengHeRen = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    HeTongJinE = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    HeTongBiao = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    TiaoKuan = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    WenBen = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_CarrierTables", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "Chargeablemanagements",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    NumBer = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Danwei = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    FangShi = table.Column<int>(type: "int", nullable: true),
                    DunWei = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Price = table.Column<decimal>(type: "decimal(18,2)", nullable: true),
                    Sum = table.Column<decimal>(type: "decimal(18,2)", nullable: true),
                    YeWu = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Ren = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    CreateDate = table.Column<DateTime>(type: "datetime2", nullable: true),
                    BeiZhu = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Sistrte = table.Column<int>(type: "int", nullable: true),
                    HeDui = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    HeDuiDate = table.Column<DateTime>(type: "datetime2", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Chargeablemanagements", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "Classes",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    ClassName = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Classes", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "CompanyInformations",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Name = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Email = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Phone = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    DiZhi = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_CompanyInformations", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "Contractmanagementables",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Contract = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Contracttitle = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Outsourcing = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Cooperation = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Chartervalue = table.Column<int>(type: "int", nullable: true),
                    Signingdate = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Agent = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Creationtime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    State = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Approver = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Contractmanagementables", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "DegreeTables",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    DegreeName = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_DegreeTables", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "Departments",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Departmentname = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Parentdepartment = table.Column<int>(type: "int", nullable: true),
                    Createtime = table.Column<DateTime>(type: "datetime2", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Departments", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "Departmenttables",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    DepartmenName = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Departmenttables", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "EmployeeNames",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    YuanGongName = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_EmployeeNames", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "EmployeeYables",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Name = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Sex = table.Column<int>(type: "int", nullable: true),
                    BuMen = table.Column<int>(type: "int", nullable: true),
                    Posts = table.Column<int>(type: "int", nullable: true),
                    Phone = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Colleges = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Specialized = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Address = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    RuDate = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Seniority = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Type = table.Column<int>(type: "int", nullable: true),
                    State = table.Column<int>(type: "int", nullable: true),
                    CreateDate = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Degree = table.Column<int>(type: "int", nullable: true),
                    Politicalface = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Ethin = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Origin = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Marriage = table.Column<int>(type: "int", nullable: true),
                    Dateofbirth = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Email = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Socialsecuritynumber = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_EmployeeYables", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "Entryapprovals",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Name = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Department = table.Column<int>(type: "int", nullable: true),
                    Position = table.Column<int>(type: "int", nullable: true),
                    Superior = table.Column<int>(type: "int", nullable: true),
                    Dateofentry = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Creationtime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Approval = table.Column<int>(type: "int", nullable: true),
                    Status = table.Column<int>(type: "int", nullable: true),
                    Approver = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Remark = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Entryapprovals", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "ExaminationTables",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Examination = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_ExaminationTables", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "Exitapprovals",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Name = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Department = table.Column<int>(type: "int", nullable: true),
                    Position = table.Column<int>(type: "int", nullable: true),
                    Superior = table.Column<int>(type: "int", nullable: true),
                    Dateofentry = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Lastworkingday = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Approval = table.Column<int>(type: "int", nullable: true),
                    Status = table.Column<int>(type: "int", nullable: true),
                    Approver = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Reasonsforseparation = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Creationtime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Approvaltime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Remark = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Exitapprovals", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "ExpenseManagementPayables",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    NumBer = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Danwei = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    FangShi = table.Column<int>(type: "int", nullable: true),
                    DunWei = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Price = table.Column<decimal>(type: "decimal(18,2)", nullable: true),
                    Sum = table.Column<decimal>(type: "decimal(18,2)", nullable: true),
                    YeWu = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Ren = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    CreateDate = table.Column<DateTime>(type: "datetime2", nullable: true),
                    BeiZhu = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Sistrte = table.Column<int>(type: "int", nullable: true),
                    HeDui = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    HeDuiDate = table.Column<DateTime>(type: "datetime2", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_ExpenseManagementPayables", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "ExpensesTables",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    BiaoTi = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Type = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    ChePaiHao = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    JinE = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Ren = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    MiaoShu = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    ShiDate = table.Column<DateTime>(type: "datetime2", nullable: true),
                    BeiZhu = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    CreteDate = table.Column<DateTime>(type: "datetime2", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_ExpensesTables", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "FaBiaoTypes",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Name = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_FaBiaoTypes", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "Fuelmanagementtables",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Licenseplate = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Comeonost = table.Column<int>(type: "int", nullable: true),
                    Amount = table.Column<int>(type: "int", nullable: true),
                    Mileage = table.Column<int>(type: "int", nullable: true),
                    Payment = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Agent = table.Column<int>(type: "int", nullable: true),
                    Note = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Creationtime = table.Column<DateTime>(type: "datetime2", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Fuelmanagementtables", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "GeneralTables",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    NumBer = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    BiaoTi = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    DuiFangDanWei = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Ren = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    QianDinDate = table.Column<DateTime>(type: "datetime2", nullable: true),
                    JinBanRen = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    CreateDate = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Sistrte = table.Column<int>(type: "int", nullable: true),
                    ShengHeRen = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    HeTongJinE = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    HeTongBiao = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    TiaoKuan = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    WenBen = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Type = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_GeneralTables", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "HeadTables",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    HeadName = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_HeadTables", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "HeDuis",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Name = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_HeDuis", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "Inboundmanagements",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    HuoName = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Type = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Material = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Specification = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Placeoforigin = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Quantity = table.Column<int>(type: "int", nullable: true),
                    Price = table.Column<int>(type: "int", nullable: true),
                    Paymentmethod = table.Column<int>(type: "int", nullable: true),
                    Purchaseamount = table.Column<int>(type: "int", nullable: true),
                    RegistrantName = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Remarks = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Creationtime = table.Column<DateTime>(type: "datetime2", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Inboundmanagements", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "Inputinvoicemanagements",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    NumBer = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Danwei = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Type = table.Column<int>(type: "int", nullable: true),
                    Jine = table.Column<decimal>(type: "decimal(18,2)", nullable: true),
                    Lu = table.Column<decimal>(type: "decimal(18,2)", nullable: true),
                    ShuiE = table.Column<decimal>(type: "decimal(18,2)", nullable: true),
                    Date = table.Column<DateTime>(type: "datetime2", nullable: true),
                    CreateDate = table.Column<DateTime>(type: "datetime2", nullable: true),
                    BeiZhu = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Name = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Inputinvoicemanagements", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "JieSuanTables",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Name = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_JieSuanTables", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "Linemanagementtables",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Nametheline = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Startingpoint = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Theend = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Outsourcing = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Shippername = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Mobilephone = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Ownerunit = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Note = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Creationtime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    State = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Linemanagementtables", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "LineTables",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    LineTable1 = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_LineTables", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "LllegalTables",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    BiaoTi = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    ChePaiHao = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    NeiRong = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Outcome = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Violators = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    WeiZhangDate = table.Column<DateTime>(type: "datetime2", nullable: true),
                    BeiZhu = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    CreateDate = table.Column<DateTime>(type: "datetime2", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_LllegalTables", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "MaintenanceTables",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Title = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Type = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Licenseplatenumber = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Repairamount = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Headofmaintenance = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Repairdescription = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    WeiDate = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Remark = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    CreateDate = table.Column<DateTime>(type: "datetime2", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_MaintenanceTables", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "Managementtables",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Name = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Departmentid = table.Column<int>(type: "int", nullable: true),
                    Positionid = table.Column<int>(type: "int", nullable: true),
                    Responsible = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Dateentry = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Workingday = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Leavingreason = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Examinationid = table.Column<int>(type: "int", nullable: true),
                    Creationtime = table.Column<DateTime>(type: "datetime2", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Managementtables", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "Managementtanbles",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Name = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Departmentid = table.Column<int>(type: "int", nullable: true),
                    Positionid = table.Column<int>(type: "int", nullable: true),
                    Thetime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Applicationdate = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Examinationid = table.Column<int>(type: "int", nullable: true),
                    Creationtime = table.Column<DateTime>(type: "datetime2", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Managementtanbles", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "MarriageTables",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    MarriageName = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_MarriageTables", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "Materialcollections",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Title = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    DescriptionofUse = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Adoptee = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    DateofAdoption = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Notes = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    CreationTime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    ApprovalStatus = table.Column<int>(type: "int", nullable: true),
                    Approver = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Materialcollections", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "MateriallistTales",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    MateriallistName = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_MateriallistTales", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "OnboardingTables",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Name = table.Column<int>(type: "int", nullable: true),
                    BuMne = table.Column<int>(type: "int", nullable: true),
                    ZhiWeir = table.Column<int>(type: "int", nullable: true),
                    Ren = table.Column<int>(type: "int", nullable: true),
                    RuDate = table.Column<DateTime>(type: "datetime2", nullable: true),
                    CreateDate = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Sitrte = table.Column<int>(type: "int", nullable: true),
                    ShengPiRen = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    BeiZhu = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_OnboardingTables", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "Operatormanagements",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    BianHao = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Name = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    GongName = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Phone = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    JueName = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    CreateTime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    State = table.Column<int>(type: "int", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Operatormanagements", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "Outsourcingunitmanagements",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Outsourcingunitname = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Mailbox = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Landline = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Phone = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Outsourcingaddress = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Creationtime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Remarks = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Outsourcingunitmanagements", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "Ownercontracts",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Contract = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Contracttitle = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Ownerunit = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Principalcargo = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Line = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Freight = table.Column<int>(type: "int", nullable: true),
                    Conditiontonnage = table.Column<int>(type: "int", nullable: true),
                    Chartervalue = table.Column<int>(type: "int", nullable: true),
                    Signed = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Agent = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Creationtime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    State = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Approver = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Ownercontracts", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "OwnercontractTables",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    NumBer = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    BiaoTi = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    DanWei = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Ren = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    XianLu = table.Column<int>(type: "int", nullable: true),
                    YunJia = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    DunWei = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    JinE = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    QianDinDate = table.Column<DateTime>(type: "datetime2", nullable: true),
                    JinBanRen = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    CreateDate = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Sistrte = table.Column<int>(type: "int", nullable: true),
                    ShengHeRen = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    HeTongJinE = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    HeTongBiao = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    TiaoKuan = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    WenBen = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_OwnercontractTables", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "Paymentapprovals",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Title = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Descriptionofpurpose = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Paymentamount = table.Column<int>(type: "int", nullable: true),
                    Paymentmethod = table.Column<int>(type: "int", nullable: true),
                    Paymentobject = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Bankaccountnumber = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Account = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Applicant = table.Column<int>(type: "int", nullable: true),
                    Paymentdate = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Remarks = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Creationtime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Approvalstatus = table.Column<int>(type: "int", nullable: true),
                    Approver = table.Column<int>(type: "int", nullable: true),
                    Approvetheresults = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Paymentapprovals", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "PaymentMethods",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Paymentname = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_PaymentMethods", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "PaymentTables",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Thetitle = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Describe = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Paymentamount = table.Column<int>(type: "int", nullable: true),
                    Payment = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Theobject = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Whereit = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Account = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Applicant = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    PaymentData = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Note = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Creationtime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Examinationid = table.Column<int>(type: "int", nullable: true),
                    Theapprover = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_PaymentTables", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "PersonnelBoardTables",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Name = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Departmentid = table.Column<int>(type: "int", nullable: true),
                    Positionid = table.Column<int>(type: "int", nullable: true),
                    Responsibleperson = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Dateofentry = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Creationtime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Examinationid = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Approver = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_PersonnelBoardTables", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "Positionmanagements",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Jobtitle = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Alias = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Createtime = table.Column<DateTime>(type: "datetime2", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Positionmanagements", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "Positiontables",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Position = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Positiontables", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "PostsTables",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    PostsName = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_PostsTables", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "Procurementofmaterialsses",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    HuoName = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Type = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Material = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Specification = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Placeoforigin = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Quantity = table.Column<int>(type: "int", nullable: true),
                    Remarks = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Creationtime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Approvalstatus = table.Column<int>(type: "int", nullable: true),
                    Descriptionofuse = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Applicant = table.Column<int>(type: "int", nullable: true),
                    Expecteddeliverydate = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Approver = table.Column<int>(type: "int", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Procurementofmaterialsses", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "PurchaseTables",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Commodity = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Type = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Materiallistid = table.Column<int>(type: "int", nullable: true),
                    Specification = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Thesurfaceid = table.Column<int>(type: "int", nullable: true),
                    Numbera = table.Column<int>(type: "int", nullable: true),
                    Describe = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Applicant = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Deliverydate = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Note = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Creationtime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Examinationid = table.Column<int>(type: "int", nullable: true),
                    Theapprover = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_PurchaseTables", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "Regularizationapprovals",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Name = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Department = table.Column<int>(type: "int", nullable: true),
                    Position = table.Column<int>(type: "int", nullable: true),
                    Uih = table.Column<int>(type: "int", nullable: true),
                    Dateofentry = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Creationtime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Approval = table.Column<int>(type: "int", nullable: true),
                    Status = table.Column<int>(type: "int", nullable: true),
                    Approver = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Remark = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Datecreated = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Thedateofapproval = table.Column<DateTime>(type: "datetime2", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Regularizationapprovals", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "Reimbursementapprovals",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Title = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    DescriptionofPurpose = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    ReimbursementAmount = table.Column<int>(type: "int", nullable: true),
                    Applicant = table.Column<int>(type: "int", nullable: true),
                    DateofApplication = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Remarks = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    CreationTime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    ApprovalStatus = table.Column<int>(type: "int", nullable: true),
                    Approver = table.Column<int>(type: "int", nullable: true),
                    ApprovalRemarks = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Reimbursementapprovals", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "Reviewprocesses",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Processname = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Menumodule = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Approvalhierarchy = table.Column<int>(type: "int", nullable: true),
                    Approvalswitch = table.Column<int>(type: "int", nullable: true),
                    Status = table.Column<int>(type: "int", nullable: true),
                    Creator = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Creationtime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Carboncopy = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Reviewprocesses", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "Rolemanagements",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Name = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Parentroles = table.Column<int>(type: "int", nullable: true),
                    Alias = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Createtime = table.Column<DateTime>(type: "datetime2", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Rolemanagements", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "SalesinvoiceTables",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Invoice = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Customer = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Invoicetype = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Invoiceamount = table.Column<int>(type: "int", nullable: true),
                    Tax = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Invoicedate = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Note = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Making = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Creationtime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Rate = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_SalesinvoiceTables", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "StateTables",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    StateName = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_StateTables", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "Student",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Name = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Birthday = table.Column<DateTime>(type: "datetime2", nullable: false),
                    Age = table.Column<int>(type: "int", nullable: false),
                    ClassID = table.Column<int>(type: "int", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Student", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "ThesurfaceTables",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    ThesurfaceName = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_ThesurfaceTables", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "Tireuses",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Licenseplatenumber = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Tirebrand = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Specification = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Num = table.Column<int>(type: "int", nullable: true),
                    UseName = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Usedate = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Remark = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Createtime = table.Column<DateTime>(type: "datetime2", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Tireuses", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "Turnovertables",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Name = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Departmentid = table.Column<int>(type: "int", nullable: true),
                    Positionid = table.Column<int>(type: "int", nullable: true),
                    Responsibleperson = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Dateofentry = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Creationtime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Examinationid = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Approver = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Leavingreason = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Turnovertables", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "Usermanages",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    User = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Paw = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Name = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    XinPaw = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    QuerenPaw = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Usermanages", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "VehicleManagements",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Brandmodel = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Licenseplatenumber = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Driversname = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Company = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Model = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Vehiclecolor = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Purchasedate = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Operationcertificatenumber = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Insuranceexpirationtime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    AnnualInspectionexpirationtime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Maintenancekilometersettings = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Vehiclephotos = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    InsuranceCardPhotos = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Zhuangtai = table.Column<int>(type: "int", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_VehicleManagements", x => x.Id);
                });
        }

        protected override void Down(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DropTable(
                name: "AccidentrecordsTables");

            migrationBuilder.DropTable(
                name: "Agenttables");

            migrationBuilder.DropTable(
                name: "BaoYangTables");

            migrationBuilder.DropTable(
                name: "BuMenTables");

            migrationBuilder.DropTable(
                name: "Cargoownermanagements");

            migrationBuilder.DropTable(
                name: "CarriagecontractTables");

            migrationBuilder.DropTable(
                name: "CarrierTables");

            migrationBuilder.DropTable(
                name: "Chargeablemanagements");

            migrationBuilder.DropTable(
                name: "Classes");

            migrationBuilder.DropTable(
                name: "CompanyInformations");

            migrationBuilder.DropTable(
                name: "Contractmanagementables");

            migrationBuilder.DropTable(
                name: "DegreeTables");

            migrationBuilder.DropTable(
                name: "Departments");

            migrationBuilder.DropTable(
                name: "Departmenttables");

            migrationBuilder.DropTable(
                name: "EmployeeNames");

            migrationBuilder.DropTable(
                name: "EmployeeYables");

            migrationBuilder.DropTable(
                name: "Entryapprovals");

            migrationBuilder.DropTable(
                name: "ExaminationTables");

            migrationBuilder.DropTable(
                name: "Exitapprovals");

            migrationBuilder.DropTable(
                name: "ExpenseManagementPayables");

            migrationBuilder.DropTable(
                name: "ExpensesTables");

            migrationBuilder.DropTable(
                name: "FaBiaoTypes");

            migrationBuilder.DropTable(
                name: "Fuelmanagementtables");

            migrationBuilder.DropTable(
                name: "GeneralTables");

            migrationBuilder.DropTable(
                name: "HeadTables");

            migrationBuilder.DropTable(
                name: "HeDuis");

            migrationBuilder.DropTable(
                name: "Inboundmanagements");

            migrationBuilder.DropTable(
                name: "Inputinvoicemanagements");

            migrationBuilder.DropTable(
                name: "JieSuanTables");

            migrationBuilder.DropTable(
                name: "Linemanagementtables");

            migrationBuilder.DropTable(
                name: "LineTables");

            migrationBuilder.DropTable(
                name: "LllegalTables");

            migrationBuilder.DropTable(
                name: "MaintenanceTables");

            migrationBuilder.DropTable(
                name: "Managementtables");

            migrationBuilder.DropTable(
                name: "Managementtanbles");

            migrationBuilder.DropTable(
                name: "MarriageTables");

            migrationBuilder.DropTable(
                name: "Materialcollections");

            migrationBuilder.DropTable(
                name: "MateriallistTales");

            migrationBuilder.DropTable(
                name: "OnboardingTables");

            migrationBuilder.DropTable(
                name: "Operatormanagements");

            migrationBuilder.DropTable(
                name: "Outsourcingunitmanagements");

            migrationBuilder.DropTable(
                name: "Ownercontracts");

            migrationBuilder.DropTable(
                name: "OwnercontractTables");

            migrationBuilder.DropTable(
                name: "Paymentapprovals");

            migrationBuilder.DropTable(
                name: "PaymentMethods");

            migrationBuilder.DropTable(
                name: "PaymentTables");

            migrationBuilder.DropTable(
                name: "PersonnelBoardTables");

            migrationBuilder.DropTable(
                name: "Positionmanagements");

            migrationBuilder.DropTable(
                name: "Positiontables");

            migrationBuilder.DropTable(
                name: "PostsTables");

            migrationBuilder.DropTable(
                name: "Procurementofmaterialsses");

            migrationBuilder.DropTable(
                name: "PurchaseTables");

            migrationBuilder.DropTable(
                name: "Regularizationapprovals");

            migrationBuilder.DropTable(
                name: "Reimbursementapprovals");

            migrationBuilder.DropTable(
                name: "Reviewprocesses");

            migrationBuilder.DropTable(
                name: "Rolemanagements");

            migrationBuilder.DropTable(
                name: "SalesinvoiceTables");

            migrationBuilder.DropTable(
                name: "StateTables");

            migrationBuilder.DropTable(
                name: "Student");

            migrationBuilder.DropTable(
                name: "ThesurfaceTables");

            migrationBuilder.DropTable(
                name: "Tireuses");

            migrationBuilder.DropTable(
                name: "Turnovertables");

            migrationBuilder.DropTable(
                name: "Usermanages");

            migrationBuilder.DropTable(
                name: "VehicleManagements");
        }
    }
}
